2. Data Preparation
Load and Combine Monthly Data
2.1 Check and Clean the Data
Check for Missing Values
Remove Missing Values
Ensure Proper Date/Time Format
Remove Duplicate Records
2.2 Add New Calculated Columns
Trip Duration
Day of Week
Hour of the Day
3. Analyze the Data
3.1 Aggregate Metrics by User Type
Total Number of Rides by User Type
|
User Type
|
Total Rides
|
|
member
|
3739923
|
|
casual
|
2159006
|
Average Trip Duration by User Type
|
User Type
|
Average Duration (minutes)
|
|
member
|
12.23080
|
|
casual
|
21.09462
|
3.2 Analyze Usage Patterns
Popular Days by User Type
Popular Days of the Week for Members
|
User Type
|
Day of Week
|
Total Rides
|
|
member
|
Wednesday
|
617838
|
|
member
|
Thursday
|
581083
|
|
member
|
Tuesday
|
568187
|
|
member
|
Friday
|
538020
|
|
member
|
Monday
|
528265
|
|
member
|
Saturday
|
487511
|
|
member
|
Sunday
|
419019
|
Popular Days of the Week for Casual Riders
|
User Type
|
Day of Week
|
Total Rides
|
|
casual
|
Saturday
|
447556
|
|
casual
|
Sunday
|
370001
|
|
casual
|
Friday
|
320149
|
|
casual
|
Wednesday
|
271281
|
|
casual
|
Thursday
|
267672
|
|
casual
|
Monday
|
250910
|
|
casual
|
Tuesday
|
231437
|
Popular Months by User Type
Popular Months for Members
|
User Type
|
Month
|
Total Rides
|
|
member
|
September
|
474285
|
|
member
|
August
|
437263
|
|
member
|
July
|
428284
|
|
member
|
June
|
409411
|
|
member
|
October
|
399759
|
|
member
|
May
|
378414
|
|
member
|
April
|
283115
|
|
member
|
November
|
241924
|
|
member
|
March
|
219023
|
|
member
|
February
|
175883
|
|
member
|
December
|
172330
|
|
member
|
January
|
120232
|
Popular Months for Casual Riders
|
User Type
|
Month
|
Total Rides
|
|
casual
|
September
|
345879
|
|
casual
|
July
|
319583
|
|
casual
|
August
|
317563
|
|
casual
|
June
|
300195
|
|
casual
|
May
|
230466
|
|
casual
|
October
|
215956
|
|
casual
|
April
|
131431
|
|
casual
|
November
|
92845
|
|
casual
|
March
|
82268
|
|
casual
|
December
|
51504
|
|
casual
|
February
|
46963
|
|
casual
|
January
|
24353
|
Popular Start Station of the Month by User Type
Top Start Stations for Members
|
Start Station
|
Month
|
User Type
|
Total Rides
|
|
Kingsbury St & Kinzie St
|
September
|
member
|
3657
|
|
Kingsbury St & Kinzie St
|
August
|
member
|
3383
|
|
Kingsbury St & Kinzie St
|
July
|
member
|
3202
|
|
University Ave & 57th St
|
October
|
member
|
3188
|
|
Kingsbury St & Kinzie St
|
June
|
member
|
2968
|
|
Clinton St & Washington Blvd
|
May
|
member
|
2720
|
|
Clinton St & Washington Blvd
|
April
|
member
|
2341
|
|
Kingsbury St & Kinzie St
|
November
|
member
|
2257
|
|
Clinton St & Washington Blvd
|
March
|
member
|
2090
|
|
Clinton St & Washington Blvd
|
February
|
member
|
1960
|
|
Clinton St & Washington Blvd
|
December
|
member
|
1620
|
|
Clinton St & Washington Blvd
|
January
|
member
|
1400
|
Top Start Stations for Casual Riders
|
Start Station
|
Month
|
User Type
|
Total Rides
|
|
Streeter Dr & Grand Ave
|
July
|
casual
|
9173
|
|
Streeter Dr & Grand Ave
|
August
|
casual
|
8549
|
|
Streeter Dr & Grand Ave
|
June
|
casual
|
7113
|
|
Streeter Dr & Grand Ave
|
September
|
casual
|
6701
|
|
Streeter Dr & Grand Ave
|
May
|
casual
|
6319
|
|
Streeter Dr & Grand Ave
|
October
|
casual
|
4873
|
|
Streeter Dr & Grand Ave
|
April
|
casual
|
3319
|
|
Streeter Dr & Grand Ave
|
March
|
casual
|
1929
|
|
Streeter Dr & Grand Ave
|
November
|
casual
|
1684
|
|
Streeter Dr & Grand Ave
|
February
|
casual
|
689
|
|
Streeter Dr & Grand Ave
|
December
|
casual
|
513
|
|
Ellis Ave & 60th St
|
January
|
casual
|
284
|
Popular End Station of the Month by User Type
Top End Stations for Members
|
End Station
|
Month
|
User Type
|
Total Rides
|
|
Kingsbury St & Kinzie St
|
September
|
member
|
3216
|
|
Kingsbury St & Kinzie St
|
August
|
member
|
3113
|
|
DuSable Lake Shore Dr & North Blvd
|
July
|
member
|
3070
|
|
University Ave & 57th St
|
October
|
member
|
3021
|
|
Kingsbury St & Kinzie St
|
June
|
member
|
2742
|
|
Clinton St & Washington Blvd
|
May
|
member
|
2457
|
|
Clinton St & Washington Blvd
|
April
|
member
|
2171
|
|
Kingsbury St & Kinzie St
|
November
|
member
|
2092
|
|
Clinton St & Washington Blvd
|
March
|
member
|
1951
|
|
Clinton St & Washington Blvd
|
February
|
member
|
1853
|
|
Clinton St & Washington Blvd
|
December
|
member
|
1578
|
|
Clinton St & Washington Blvd
|
January
|
member
|
1406
|
Top End Stations for Casual Riders
|
End Station
|
Month
|
User Type
|
Total Rides
|
|
Streeter Dr & Grand Ave
|
July
|
casual
|
9456
|
|
Streeter Dr & Grand Ave
|
August
|
casual
|
8795
|
|
Streeter Dr & Grand Ave
|
June
|
casual
|
7304
|
|
Streeter Dr & Grand Ave
|
September
|
casual
|
6911
|
|
Streeter Dr & Grand Ave
|
May
|
casual
|
6376
|
|
Streeter Dr & Grand Ave
|
October
|
casual
|
5093
|
|
Streeter Dr & Grand Ave
|
April
|
casual
|
3275
|
|
Streeter Dr & Grand Ave
|
March
|
casual
|
2018
|
|
Streeter Dr & Grand Ave
|
November
|
casual
|
1823
|
|
Streeter Dr & Grand Ave
|
February
|
casual
|
749
|
|
Streeter Dr & Grand Ave
|
December
|
casual
|
576
|
|
University Ave & 57th St
|
January
|
casual
|
241
|
Peak Hours by User Type
Peak Hours of the Day for Members (Average Rides)
|
Hour of Day
|
User Type
|
Total Rides
|
|
17
|
member
|
296091
|
|
16
|
member
|
256493
|
|
18
|
member
|
220849
|
|
8
|
member
|
194853
|
|
15
|
member
|
184861
|
|
7
|
member
|
157949
|
|
19
|
member
|
152854
|
|
14
|
member
|
150207
|
|
12
|
member
|
150041
|
|
13
|
member
|
149468
|
|
11
|
member
|
131538
|
|
9
|
member
|
128391
|
Peak Hours of the Day for Casual Riders (Average Rides)
|
Hour of Day
|
User Type
|
Total Rides
|
|
17
|
casual
|
147297
|
|
16
|
casual
|
139583
|
|
15
|
casual
|
123407
|
|
18
|
casual
|
121586
|
|
14
|
casual
|
113113
|
|
13
|
casual
|
109257
|
|
12
|
casual
|
105396
|
|
11
|
casual
|
90073
|
|
19
|
casual
|
87446
|
|
10
|
casual
|
70819
|
|
20
|
casual
|
63083
|
|
9
|
casual
|
55560
|
4. Visualize Insights
Popular Start Station of the Month by User Type
## Registered S3 method overwritten by 'jsonify':
## method from
## print.json jsonlite
Map of popular start stations using leaflet
Popular End Station of the Month by User Type
Map of Popular End Stations Using Leaflet
5. Summarize and Recommendations
Key Findings
- Usage Trends: Members take more rides overall but
have shorter trip durations on average.
- Casual Riders: Ride primarily on weekends and
during leisure hours.
- Members: Use bikes more consistently across the
week, especially during commute hours.
Recommendations
- Design weekend promotions targeting casual riders.
- Highlight the benefits of annual memberships for regular commuting
needs.
- Increase marketing efforts at popular casual rider stations to
convert them to members.